SMFCSD Salaries Report

CAUTION There are three kinds of lies: lies, damned lies, and statistics.
In [1]:
import cufflinks as cf
import pandas as pd
import numpy as np

import plotly.offline as py
import plotly.graph_objs as go

from IPython.display import display, Markdown, Latex

py.init_notebook_mode(connected=True)

cf.set_config_file(offline=True)

pd.options.display.float_format = '{:20,.2f}'.format
In [2]:
# main data-frame init

dtype = {'County': np.str,
         'Employee Name': np.str,
         'Job Title': np.str,
         'Year': np.int64,
         'Notes': np.str,
         'Agency': np.str,
         'Status': np.str}


def to_float(x):
    try:
        return float(x)
    except Exception as e:
        return None


converters = {'Base Pay': to_float,
              'Overtime Pay': to_float,
              'Other Pay': to_float,
              'Benefits': to_float,
              'Total Pay': to_float,
              'Total Pay & Benefits': to_float}

df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
In [6]:
# definitions

ENTITIES_MAPPING = {
    'Teachers': '(?i)teacher|tchr',
    'Managers': '(?i)principal|director|chief|intendent|administrator|coordinator|mgr',
    'Superintendents': '(?i)superintendent|supt'
}
ENTITIES = ['Teachers', 'Managers', 'Superintendents']
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
HIGHLIGHT_AGECNY = 'San Mateo-Foster City'

def get_df(county, entity, year):
    return df[(df['County'] == county) & 
              (df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) & 
              (df['Year'] == year)] 

def display_mean_salary_by_year(county, entity, year):
    ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
    ga_mean = ga.mean()
    ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
    
   
    bar = go.Bar(x=ga_mean['Agency'],
                 y=ga_mean['Total Pay & Benefits'],
                 marker=dict(color=np.where(ga_mean['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
    layout = go.Layout(
        margin=go.Margin(
            l=60,
            r=50,
            b=150,
            t=100,
            pad=2
        ),
        title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                entity=entity, 
                                                                year=year),
        xaxis=dict(
            title='Agency',
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        ),
        yaxis=dict(
            title='Mean Salary (USD)',
            titlefont=dict(
                size=16,
                color='rgb(107, 107, 107)'
            ),
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        )
    )
    fig = go.Figure(data=[bar], layout=layout)
    py.offline.iplot(fig, filename='basic-bar')
    
    """    
    ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                          entity=entity, 
                                                                          year=year), 
                  x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart',
                  xTitle='Agencies', yTitle='Mean Salary', colors={'Agency': 'red', 'Total Pay & Benefits': 'black'})
    """
    
    # print table under graph
    ga_descr = ga.describe()  
    #ga_descr[ga_descr.columns] = ga_descr[ga_descr.columns].fillna(0).astype(np.int64)   
    display(ga_descr.sort_values(by='mean', ascending=False))

    
def display_cumul_salary_change(county, entity, year_from, year_to):
    dt = df[(df['County'] == county) & 
              (df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) & 
              ((df['Year'] == year_from) | (df['Year'] == year_to))]
    dt = dt.groupby(['Agency', 'Year'])['Total Pay & Benefits'].mean().to_frame().reset_index()    
    dt = dt.pivot_table(columns=['Year'], values='Total Pay & Benefits', index=['Agency']).reset_index()
    dt.columns = ['Agency', 'year_from', 'year_to'] # because numbers in column names doesn't work
    dt['diff'] = dt.apply(lambda row: (row['year_to'] - row['year_from']) * 100 / row['year_from'], axis=1)
    dt = dt[(dt['diff'].notnull())]
    dt = dt.sort_values(by='diff', ascending=False)
   
    bar = go.Bar(x=dt['Agency'],
                 y=dt['diff'],
                 marker=dict(color=np.where(dt['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
    layout = go.Layout(
        margin=go.Margin(
            l=60,
            r=50,
            b=150,
            t=100,
            pad=2
        ),
        title='{county}, {entity}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county, 
                                                                entity=entity, 
                                                                year_from=year_from,
                                                                year_to=year_to),
        xaxis=dict(
            title='Agency',
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        ),
        yaxis=dict(
            title='Salary Change (%)',
            titlefont=dict(
                size=16,
                color='rgb(107, 107, 107)'
            ),
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        )
    )
    fig = go.Figure(data=[bar], layout=layout)
    py.offline.iplot(fig, filename='basic-bar')
In [7]:
# Salary change

year_from = min(YEARS)
year_to = max(YEARS)

for county in COUNTIES:
    display(Markdown('# {county}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county,
                                                                                              year_from=year_from,
                                                                                              year_to=year_to)))
    for entity in ENTITIES:
        display(Markdown('## {entity}'.format(entity=entity)))
        display_cumul_salary_change(county, entity, year_from, year_to)

San Mateo County, Cumulative Mean Salary Change in 2012 - 2016

Teachers

Managers

Superintendents

In [8]:
# Mean salary

year_from = min(YEARS)
year_to = max(YEARS)

for county in COUNTIES:
    display(Markdown('# {county}, Mean Salary in {year_from} - {year_to}'.format(county=county,
                                                                                 year_from=year_from,
                                                                                 year_to=year_to)))
    for year in YEARS:
        display(Markdown('## {year}'.format(year=year)))
        
        for entity in ENTITIES:
            display(Markdown('### {entity}'.format(entity=entity)))
            display_mean_salary_by_year(county, entity, year)

San Mateo County, Mean Salary in 2012 - 2016

2016

Teachers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 51.00 114,308.22 35,249.92 24,441.29 103,155.85 121,072.10 141,348.27 155,939.98
Las Lomitas Elementary 86.00 112,186.29 34,589.27 17,674.21 101,644.44 124,789.11 135,003.10 162,679.42
Menlo Park City Elementary 197.00 109,100.83 31,872.65 4,772.96 93,540.96 120,378.59 132,307.00 149,728.85
San Mateo Union High 516.00 89,637.90 55,348.64 0.00 43,487.97 110,342.98 136,326.11 177,103.02
Redwood City Elementary 414.00 84,091.86 30,399.76 3,467.76 66,821.58 90,014.50 108,050.12 130,262.17
San Mateo County Office of Education 98.00 81,386.74 51,924.93 161.00 34,584.75 87,253.00 130,387.50 162,407.00
San Mateo-Foster City 671.00 80,915.34 34,628.19 0.00 56,369.85 88,089.60 109,455.35 130,813.29
San Carlos Elementary 179.00 80,820.37 30,054.58 10,515.54 62,665.38 93,103.93 101,742.90 118,654.71
Belmont-Redwood Shores Elementary 212.00 80,434.73 30,277.63 1.00 63,843.00 84,095.00 104,613.75 141,135.00
Pacifica School District 166.00 78,638.99 31,585.52 0.00 56,373.25 88,943.20 105,053.93 126,200.80
South San Francisco Unified 361.00 76,595.15 26,264.21 0.00 65,551.00 79,782.00 96,918.00 127,910.00
Burlingame Elementary 184.00 74,049.30 27,328.24 4,156.15 54,526.63 77,799.64 96,986.45 116,783.89
Bayshore Elementary 23.00 71,390.65 24,179.92 23,153.00 64,017.00 76,141.00 85,656.50 102,482.00
La Honda-Pescadero Unified 38.00 66,915.00 30,181.64 24.70 47,218.51 72,050.93 87,400.46 124,795.88

Managers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 8.00 177,613.95 61,283.00 42,479.98 176,001.38 185,905.33 199,468.78 246,767.16
Menlo Park City Elementary 18.00 173,413.65 37,883.54 98,821.54 147,614.50 172,950.27 196,669.25 274,717.64
San Mateo-Foster City 47.00 163,747.96 47,401.06 43,060.05 146,228.26 180,012.11 192,097.29 270,074.32
Burlingame Elementary 17.00 156,509.58 46,148.23 64,474.57 137,023.89 151,988.99 172,007.33 293,857.48
Pacifica School District 17.00 146,165.94 53,597.25 14,546.44 131,817.65 150,180.96 162,938.29 248,636.70
San Mateo Union High 48.00 144,990.26 81,074.66 0.00 81,295.07 171,328.46 205,726.11 348,435.74
Belmont-Redwood Shores Elementary 18.00 144,171.11 38,923.05 78,340.00 118,907.00 147,838.50 166,497.75 234,988.00
San Mateo County Office of Education 66.00 138,959.92 60,035.16 307.00 103,615.00 161,025.50 170,897.75 272,407.00
Las Lomitas Elementary 14.00 133,539.24 66,527.87 7,660.25 86,047.24 154,019.27 177,037.73 248,142.92
San Carlos Elementary 20.00 130,715.05 53,636.19 11,095.54 119,545.74 135,984.28 155,519.22 238,839.36
South San Francisco Unified 31.00 126,889.58 48,697.40 0.00 85,846.50 142,932.00 158,596.00 225,309.00
Redwood City Elementary 64.00 124,707.83 45,997.44 44,739.55 80,486.20 131,188.83 160,821.58 268,113.54
Bayshore Elementary 5.00 107,142.00 55,260.83 54,525.00 56,846.00 101,871.00 138,462.00 184,006.00
La Honda-Pescadero Unified 8.00 88,910.23 42,648.93 20,385.03 53,595.81 101,808.99 120,146.37 138,866.25

Superintendents

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 3.00 290,160.61 58,516.90 231,404.91 261,023.05 290,641.19 319,538.46 348,435.74
Redwood City Elementary 1.00 268,113.54 nan 268,113.54 268,113.54 268,113.54 268,113.54 268,113.54
Portola Valley Elementary 1.00 246,767.16 nan 246,767.16 246,767.16 246,767.16 246,767.16 246,767.16
Menlo Park City Elementary 2.00 243,201.23 44,570.94 211,684.81 227,443.02 243,201.23 258,959.43 274,717.64
San Mateo-Foster City 5.00 234,524.79 62,380.28 124,306.70 246,211.83 261,924.45 270,074.32 270,106.67
San Mateo County Office of Education 5.00 229,732.20 26,019.06 204,120.00 215,341.00 225,221.00 231,572.00 272,407.00
Pacifica School District 2.00 224,064.61 34,750.18 199,492.52 211,778.57 224,064.61 236,350.66 248,636.70
Burlingame Elementary 3.00 221,090.65 63,018.18 184,528.35 184,707.23 184,886.11 239,371.79 293,857.48
San Carlos Elementary 2.00 211,754.71 38,303.48 184,670.06 198,212.38 211,754.71 225,297.03 238,839.36
Bayshore Elementary 1.00 184,006.00 nan 184,006.00 184,006.00 184,006.00 184,006.00 184,006.00
Belmont-Redwood Shores Elementary 2.00 175,290.50 84,425.01 115,593.00 145,441.75 175,290.50 205,139.25 234,988.00
South San Francisco Unified 3.00 169,704.00 66,012.77 96,749.00 141,901.50 187,054.00 206,181.50 225,309.00
Las Lomitas Elementary 2.00 164,871.74 117,763.23 81,600.56 123,236.15 164,871.74 206,507.33 248,142.92
La Honda-Pescadero Unified 2.00 113,445.35 35,950.58 88,024.45 100,734.90 113,445.35 126,155.80 138,866.25

2015

Teachers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 388.00 117,053.42 38,169.12 1,199.06 97,240.68 129,096.21 146,170.96 195,573.51
Menlo Park City Elementary 210.00 106,634.16 38,686.06 1,314.29 85,142.04 121,874.85 136,013.63 152,600.47
Woodside Elementary 39.00 105,741.35 32,786.61 35,032.81 85,672.04 115,348.25 127,850.42 165,303.09
Hillsborough City Elementary 135.00 105,162.21 36,274.90 14,200.68 82,639.96 117,400.88 132,841.88 156,858.61
San Carlos Elementary 180.00 83,407.44 27,958.95 466.41 71,778.05 93,333.76 103,788.60 120,869.68
San Mateo-Foster City 629.00 83,212.40 29,649.92 0.00 66,751.62 90,426.97 106,376.27 130,413.40
Cabrillo Unified 184.00 81,777.17 34,833.83 881.28 62,324.38 85,248.49 110,965.51 151,335.71
South San Francisco Unified 462.00 79,156.75 26,248.53 7,958.79 66,955.60 84,441.05 100,269.82 134,160.62
Jefferson Elementary 352.00 78,553.44 29,733.54 1,159.30 62,450.78 85,683.54 101,899.68 130,453.74
Las Lomitas Elementary 147.00 76,413.64 60,059.38 0.00 5,274.05 96,178.84 131,790.18 164,809.81
Pacifica School District 167.00 74,941.96 32,807.89 279.69 44,251.46 84,648.41 102,492.52 124,831.43
Millbrae Elementary 145.00 72,698.63 31,377.97 1,219.43 42,626.00 78,673.19 100,827.27 122,979.02
La Honda-Pescadero Unified 37.00 72,450.63 33,348.15 66.35 60,311.79 80,146.95 92,991.62 129,516.80
Belmont-Redwood Shores Elementary 293.00 62,663.58 44,117.38 75.50 17,713.82 70,308.95 101,781.41 138,947.88
Redwood City Elementary 683.00 58,250.73 40,445.78 0.00 18,701.51 59,961.68 97,720.35 127,244.90
Bayshore Elementary 26.00 57,759.40 28,857.41 3,612.80 34,075.67 65,248.93 75,227.95 103,615.24
Burlingame Elementary 289.00 52,548.26 39,689.07 0.00 10,129.91 52,903.21 91,831.64 115,200.73

Managers

count mean std min 25% 50% 75% max
Agency
Hillsborough City Elementary 9.00 180,800.32 48,691.11 89,546.44 178,676.13 188,815.96 201,455.00 253,150.62
San Mateo-Foster City 45.00 163,453.69 38,300.74 55,680.49 150,691.84 178,892.65 187,747.81 209,969.37
San Mateo Union High 48.00 162,372.42 56,422.34 40,899.38 120,110.58 170,361.15 202,151.73 330,816.69
Burlingame Elementary 16.00 158,781.12 56,372.03 60,098.64 149,678.27 163,433.36 182,022.72 300,712.30
Las Lomitas Elementary 13.00 154,780.36 60,250.47 42,041.51 98,274.71 178,123.46 195,590.94 235,632.38
San Carlos Elementary 17.00 148,119.06 41,460.94 65,947.53 133,616.68 150,414.23 160,459.65 246,861.84
Woodside Elementary 10.00 146,346.10 56,557.11 96,975.96 106,643.71 132,557.42 164,218.93 287,480.51
Menlo Park City Elementary 22.00 144,039.27 70,105.08 1,320.89 90,810.63 160,612.41 199,705.55 269,385.57
Pacifica School District 16.00 143,586.61 51,778.18 49,589.52 117,958.86 148,467.15 170,896.62 237,194.10
Belmont-Redwood Shores Elementary 18.00 136,505.66 62,247.33 1,480.75 119,556.50 161,408.12 172,981.58 233,844.88
Jefferson Elementary 33.00 131,931.96 46,705.99 11,055.74 113,202.78 149,025.20 156,861.90 244,588.82
South San Francisco Unified 35.00 131,053.26 37,018.92 37,939.40 114,083.72 143,519.45 149,974.70 205,408.48
Cabrillo Unified 26.00 119,746.42 40,810.63 33,606.67 94,466.94 125,645.21 147,493.99 200,071.38
Redwood City Elementary 69.00 114,775.72 48,898.52 2,501.31 81,115.01 119,202.99 154,442.34 223,152.08
Millbrae Elementary 14.00 114,471.56 51,463.79 48,777.38 61,762.23 123,167.40 152,566.90 185,831.11
La Honda-Pescadero Unified 8.00 100,584.11 42,463.12 39,869.34 58,961.45 120,584.01 131,331.61 144,991.75
Bayshore Elementary 5.00 87,705.18 30,488.51 56,680.98 63,276.75 89,705.70 95,373.64 133,488.81

Superintendents

count mean std min 25% 50% 75% max
Agency
Woodside Elementary 1.00 287,480.51 nan 287,480.51 287,480.51 287,480.51 287,480.51 287,480.51
Hillsborough City Elementary 1.00 253,150.62 nan 253,150.62 253,150.62 253,150.62 253,150.62 253,150.62
Menlo Park City Elementary 2.00 241,436.48 39,525.98 213,487.40 227,461.94 241,436.48 255,411.03 269,385.57
San Mateo Union High 4.00 238,103.05 64,154.91 184,304.04 204,750.93 218,645.73 251,997.85 330,816.69
Las Lomitas Elementary 1.00 235,632.38 nan 235,632.38 235,632.38 235,632.38 235,632.38 235,632.38
Burlingame Elementary 3.00 227,565.73 63,431.13 187,722.55 190,992.44 194,262.33 247,487.32 300,712.30
San Carlos Elementary 2.00 217,249.02 41,878.86 187,636.19 202,442.60 217,249.02 232,055.43 246,861.84
Pacifica School District 2.00 211,077.69 36,934.18 184,961.28 198,019.48 211,077.69 224,135.90 237,194.10
San Mateo-Foster City 5.00 197,145.78 64,760.12 122,130.64 132,572.30 226,671.96 247,185.88 257,168.11
Jefferson Elementary 5.00 184,087.31 54,613.49 101,801.80 173,838.48 179,114.36 221,093.07 244,588.82
Redwood City Elementary 2.00 177,061.68 65,181.67 130,971.28 154,016.48 177,061.68 200,106.88 223,152.08
South San Francisco Unified 4.00 169,479.33 25,143.86 151,963.97 152,162.23 160,272.43 177,589.52 205,408.48
La Honda-Pescadero Unified 1.00 144,991.75 nan 144,991.75 144,991.75 144,991.75 144,991.75 144,991.75
Millbrae Elementary 3.00 130,687.48 45,599.92 97,746.70 104,665.14 111,583.57 147,157.88 182,732.18
Cabrillo Unified 5.00 120,942.59 34,903.87 83,882.00 108,345.55 108,645.35 126,715.60 177,124.43
Belmont-Redwood Shores Elementary 3.00 116,929.98 115,045.04 3,850.73 58,472.53 113,094.34 173,469.61 233,844.88
Bayshore Elementary 1.00 89,705.70 nan 89,705.70 89,705.70 89,705.70 89,705.70 89,705.70

2014

Teachers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 52.00 105,835.64 37,843.49 19,043.07 84,528.15 118,646.98 136,825.63 150,799.05
San Mateo Union High 416.00 103,967.96 39,288.93 0.00 79,755.12 116,578.34 134,148.12 174,815.47
Menlo Park City Elementary 186.00 100,413.68 29,965.09 11,063.51 84,839.62 111,633.74 122,127.92 155,511.51
Hillsborough City Elementary 121.00 100,334.02 32,384.40 2,340.89 84,872.43 112,626.72 124,116.39 143,246.43
San Mateo County Office of Education 104.00 86,916.35 40,062.15 395.31 65,118.26 106,390.46 119,053.27 136,965.99
Jefferson Elementary 332.00 76,217.28 25,110.28 3,763.12 63,432.53 82,794.68 95,520.44 119,883.27
Belmont-Redwood Shores Elementary 217.00 74,392.10 30,452.18 3,774.79 49,936.49 80,745.93 100,871.89 126,241.04
Redwood City Elementary 495.00 74,273.03 30,093.96 351.67 48,675.15 77,395.72 99,867.10 121,788.88
Brisbane Elementary 37.00 73,454.80 28,064.80 11,053.65 50,678.81 85,438.75 94,788.67 118,708.63
Pacifica School District 165.00 73,329.55 31,912.64 678.11 44,900.92 83,471.82 100,356.14 121,840.67
Ravenswood City Elementary 197.00 71,128.68 25,138.88 0.00 56,524.67 73,807.54 88,427.73 115,228.80
Millbrae Elementary 139.00 71,015.98 30,785.37 17.22 46,388.65 78,047.89 96,976.98 119,780.36
Las Lomitas Elementary 148.00 69,855.70 53,581.00 160.59 7,628.11 78,512.02 120,401.01 150,214.89
San Carlos Elementary 166.00 67,331.71 20,636.47 7,099.70 56,748.88 72,876.01 81,953.33 92,283.37
Jefferson Union High 307.00 67,162.87 36,646.41 787.85 36,045.01 73,695.53 96,644.91 139,596.81
San Bruno Park Elementary 127.00 67,075.63 22,418.21 10,196.68 54,798.21 72,355.32 83,035.36 102,585.78
San Mateo-Foster City 689.00 66,616.08 39,514.74 0.00 29,700.67 74,407.94 98,813.28 146,467.25
La Honda-Pescadero Unified 39.00 65,014.45 30,052.89 12,498.98 37,932.88 63,799.98 91,097.86 111,784.48
Burlingame Elementary 300.00 47,605.96 39,188.40 66.00 3,930.75 47,564.80 84,949.23 109,924.81

Managers

count mean std min 25% 50% 75% max
Agency
Hillsborough City Elementary 10.00 180,388.53 30,067.64 111,214.08 174,417.65 179,081.24 191,583.93 230,110.31
San Mateo Union High 47.00 158,818.72 67,378.99 16,149.91 107,590.67 157,317.75 206,733.38 349,292.66
Las Lomitas Elementary 12.00 156,136.74 57,812.96 10,059.15 147,733.77 176,674.14 184,682.87 222,583.06
Portola Valley Elementary 7.00 154,660.99 62,167.44 43,745.94 127,323.51 179,101.17 192,935.72 219,261.33
Menlo Park City Elementary 17.00 144,489.42 53,016.32 21,375.38 127,400.90 156,662.77 175,083.73 237,957.52
Burlingame Elementary 15.00 144,127.19 46,276.51 85,085.58 113,742.41 147,852.91 159,418.66 269,387.20
Pacifica School District 15.00 142,035.24 48,802.13 54,837.09 123,938.61 152,575.98 162,585.12 229,580.87
San Mateo-Foster City 52.00 141,359.10 48,790.40 3,285.24 138,554.58 156,644.67 163,243.26 295,265.20
San Mateo County Office of Education 56.00 135,628.13 52,746.43 2,930.23 112,267.52 146,280.33 167,618.41 269,154.10
Belmont-Redwood Shores Elementary 15.00 131,557.14 45,128.99 62,544.65 97,013.68 139,405.83 151,779.00 230,557.28
Jefferson Elementary 33.00 117,788.29 47,890.67 10,085.22 80,032.40 137,120.86 143,588.89 225,706.35
San Carlos Elementary 15.00 116,900.91 22,790.03 72,134.56 108,930.33 117,762.96 124,632.11 171,667.00
Redwood City Elementary 67.00 111,480.65 47,938.47 863.21 76,811.44 118,475.80 149,927.14 229,521.57
La Honda-Pescadero Unified 7.00 100,045.50 19,832.26 60,268.82 97,482.04 101,856.17 111,029.57 121,170.31
Millbrae Elementary 15.00 96,670.52 62,496.14 328.69 49,454.32 94,317.80 142,291.30 209,097.50
Brisbane Elementary 6.00 86,987.40 66,854.66 2,191.88 50,682.93 79,517.39 112,352.65 196,328.58
Ravenswood City Elementary 56.00 85,117.98 46,932.07 3,049.15 46,051.26 91,903.89 125,397.60 219,733.88
Jefferson Union High 47.00 84,798.16 61,408.37 489.14 32,553.46 86,571.84 139,890.21 225,689.78
San Bruno Park Elementary 20.00 80,781.81 31,011.77 30,670.58 59,433.24 80,093.88 104,825.03 147,856.33

Superintendents

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 3.00 296,204.93 47,582.96 257,396.97 269,661.06 281,925.15 315,608.91 349,292.66
Menlo Park City Elementary 1.00 237,957.52 nan 237,957.52 237,957.52 237,957.52 237,957.52 237,957.52
San Mateo-Foster City 5.00 219,868.34 64,729.58 116,589.04 221,464.88 227,518.18 238,504.41 295,265.20
San Mateo County Office of Education 5.00 216,476.90 31,660.57 192,543.96 192,956.34 206,971.77 220,758.31 269,154.10
Pacifica School District 2.00 202,644.54 38,093.73 175,708.20 189,176.37 202,644.54 216,112.70 229,580.87
Hillsborough City Elementary 2.00 201,733.65 40,130.66 173,356.99 187,545.32 201,733.65 215,921.98 230,110.31
Redwood City Elementary 3.00 197,373.02 30,135.73 169,765.51 181,298.74 192,831.98 211,176.78 229,521.57
Jefferson Elementary 4.00 194,984.12 28,448.48 159,851.30 179,638.17 197,189.42 212,535.37 225,706.35
Belmont-Redwood Shores Elementary 3.00 175,930.99 57,906.98 115,223.32 148,617.85 182,012.37 206,284.83 230,557.28
Burlingame Elementary 4.00 155,992.73 84,868.02 88,124.54 92,392.36 133,229.59 196,829.96 269,387.20
Las Lomitas Elementary 2.00 155,255.91 95,214.97 87,928.76 121,592.33 155,255.91 188,919.48 222,583.06
San Carlos Elementary 2.00 153,833.50 25,220.38 136,000.00 144,916.75 153,833.50 162,750.25 171,667.00
San Bruno Park Elementary 1.00 147,856.33 nan 147,856.33 147,856.33 147,856.33 147,856.33 147,856.33
Millbrae Elementary 2.00 147,794.34 86,695.76 86,491.18 117,142.76 147,794.34 178,445.92 209,097.50
Brisbane Elementary 2.00 143,652.97 74,494.56 90,977.36 117,315.17 143,652.97 169,990.77 196,328.58
Jefferson Union High 6.00 143,612.26 67,642.88 30,418.29 118,954.05 159,840.73 175,379.33 225,689.78
Ravenswood City Elementary 6.00 127,551.63 54,939.37 77,512.55 83,183.35 120,017.54 147,846.62 219,733.88
La Honda-Pescadero Unified 1.00 121,170.31 nan 121,170.31 121,170.31 121,170.31 121,170.31 121,170.31
Portola Valley Elementary 1.00 43,745.94 nan 43,745.94 43,745.94 43,745.94 43,745.94 43,745.94

2013

Teachers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 438.00 106,746.38 32,364.59 6,441.78 91,408.80 118,055.93 130,396.84 168,120.68
Menlo Park City Elementary 185.00 105,104.41 30,059.19 24,090.59 94,554.82 115,788.83 126,987.88 153,199.80
Portola Valley Elementary 51.00 100,642.73 32,682.52 27,403.30 83,698.24 111,475.08 127,329.18 142,243.51
Woodside Elementary 42.00 91,489.52 35,015.90 27,239.60 61,736.57 105,456.31 119,330.60 153,219.27
San Mateo County Office of Education 107.00 86,761.85 43,038.56 172.39 46,162.77 108,267.94 119,327.44 136,325.97
Brisbane Elementary 31.00 77,818.67 18,070.36 18,839.57 71,261.17 81,433.83 87,380.96 105,451.17
San Carlos Elementary 161.00 76,820.16 25,046.03 10,598.42 63,564.87 82,375.41 97,196.71 112,622.01
Redwood City Elementary 449.00 75,288.02 25,819.08 1,834.92 60,152.63 81,916.51 96,344.24 116,783.84
Cabrillo Unified 183.00 75,205.05 36,026.07 110.00 49,244.57 87,243.61 104,155.54 142,403.74
Belmont-Redwood Shores Elementary 205.00 73,109.07 30,021.01 2,665.76 59,466.52 80,115.69 97,904.88 123,762.26
Sequoia Union High 702.00 72,672.85 51,505.80 81.19 13,990.29 83,943.70 120,171.14 156,745.76
Jefferson Elementary 305.00 71,644.48 21,574.01 4,925.83 58,902.86 77,942.15 88,039.29 109,289.78
San Mateo-Foster City 603.00 71,276.45 26,144.00 583.81 57,710.00 77,824.31 91,138.24 112,736.83
Las Lomitas Elementary 143.00 70,782.84 54,023.51 95.44 7,836.59 81,882.30 122,727.04 152,121.77
South San Francisco Unified 468.00 70,256.05 24,695.86 958.73 60,398.03 75,477.73 89,180.58 122,537.33
Pacifica School District 161.00 70,103.76 28,779.30 4,844.49 53,541.39 78,631.27 93,947.82 114,053.43
Millbrae Elementary 126.00 69,823.92 27,954.43 5,995.26 52,522.74 79,981.64 94,162.41 112,745.96
Burlingame Elementary 174.00 68,961.49 26,729.16 16,394.88 46,036.80 74,302.80 91,756.54 112,808.86
Ravenswood City Elementary 213.00 65,991.92 26,802.79 2,211.88 41,526.00 71,886.56 85,880.97 111,852.33
Hillsborough City Elementary 200.00 57,354.30 48,936.88 67.50 2,530.37 55,736.11 108,284.97 140,377.22
Jefferson Union High 320.00 55,105.38 37,056.50 3.64 16,885.65 64,265.88 86,367.07 125,814.87
La Honda-Pescadero Unified 42.00 51,679.88 30,051.52 1,745.12 26,156.20 53,969.84 74,093.12 108,244.30
Bayshore Elementary 33.00 39,379.46 31,633.67 135.31 5,022.80 33,913.54 63,776.90 97,785.69

Managers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 40.00 156,298.82 45,256.94 59,251.83 119,124.96 165,984.58 182,164.99 258,306.10
Menlo Park City Elementary 13.00 152,274.04 55,485.92 18,852.54 143,425.06 150,900.46 185,098.21 245,983.71
Las Lomitas Elementary 10.00 151,517.41 51,373.59 23,094.62 151,314.22 166,578.73 175,308.22 213,357.76
Hillsborough City Elementary 12.00 150,139.37 43,485.48 82,671.33 127,148.19 159,164.93 171,468.17 228,250.83
San Mateo-Foster City 43.00 144,082.81 33,332.98 58,301.25 136,475.63 148,277.24 154,452.49 282,214.43
Pacifica School District 13.00 137,986.12 40,797.00 48,149.41 124,462.58 136,397.32 155,031.49 211,025.07
San Mateo County Office of Education 53.00 132,241.92 49,358.65 1,314.09 106,435.92 142,842.37 161,822.62 240,595.31
Woodside Elementary 8.00 131,286.91 58,901.52 41,176.92 97,223.50 131,459.23 155,005.27 235,320.41
Burlingame Elementary 13.00 127,293.62 56,954.35 52,437.15 82,092.05 144,861.11 149,447.35 250,942.90
Sequoia Union High 32.00 125,952.62 60,181.08 5,816.90 89,955.01 126,024.04 175,617.50 253,867.20
South San Francisco Unified 37.00 123,805.74 32,799.88 46,769.29 116,986.07 124,591.81 138,568.72 226,915.94
Jefferson Elementary 30.00 121,266.00 28,642.76 50,362.61 111,583.71 123,939.93 131,303.33 202,870.52
San Carlos Elementary 15.00 119,201.79 45,586.65 28,793.78 95,778.90 132,528.30 139,505.67 216,285.71
Belmont-Redwood Shores Elementary 19.00 118,533.85 38,676.60 66,349.20 87,152.72 114,703.60 144,310.93 219,341.77
Bayshore Elementary 2.00 114,167.58 1,071.69 113,409.78 113,788.68 114,167.58 114,546.48 114,925.38
Portola Valley Elementary 8.00 113,462.73 48,735.87 32,480.14 88,535.17 107,836.01 143,963.39 187,476.00
Brisbane Elementary 4.00 104,810.08 74,776.69 19,635.50 69,039.40 99,802.46 135,573.14 199,999.89
Redwood City Elementary 63.00 101,719.05 38,955.15 18,601.75 72,021.24 98,419.61 132,855.55 222,483.60
Millbrae Elementary 13.00 101,319.82 54,971.54 30,219.41 50,887.38 123,335.76 129,314.62 208,543.22
Jefferson Union High 34.00 99,115.38 44,140.54 8,907.28 66,025.80 106,821.92 128,106.39 202,264.92
Ravenswood City Elementary 53.00 86,358.59 45,862.79 13,769.24 43,308.32 92,420.34 122,918.76 177,308.07
La Honda-Pescadero Unified 6.00 86,059.64 19,755.72 51,887.96 82,776.65 89,011.26 92,377.01 112,249.99
Cabrillo Unified 30.00 83,642.48 58,313.42 132.00 33,707.04 85,485.36 134,401.96 212,956.80

Superintendents

count mean std min 25% 50% 75% max
Agency
Menlo Park City Elementary 1.00 245,983.71 nan 245,983.71 245,983.71 245,983.71 245,983.71 245,983.71
San Mateo Union High 3.00 238,390.98 33,790.30 199,376.14 228,433.42 257,490.69 257,898.40 258,306.10
Woodside Elementary 1.00 235,320.41 nan 235,320.41 235,320.41 235,320.41 235,320.41 235,320.41
San Carlos Elementary 1.00 216,285.71 nan 216,285.71 216,285.71 216,285.71 216,285.71 216,285.71
Sequoia Union High 5.00 205,266.49 45,315.01 130,332.85 212,783.63 213,410.18 215,938.61 253,867.20
San Mateo County Office of Education 6.00 195,303.72 31,354.02 146,179.98 185,551.14 194,417.73 208,816.39 240,595.31
Hillsborough City Elementary 2.00 191,168.64 52,442.13 154,086.46 172,627.55 191,168.64 209,709.74 228,250.83
Redwood City Elementary 3.00 183,575.00 36,628.69 149,759.23 164,120.70 178,482.16 200,482.88 222,483.60
Pacifica School District 2.00 183,028.28 39,593.44 155,031.49 169,029.89 183,028.28 197,026.67 211,025.07
South San Francisco Unified 4.00 182,013.99 30,112.35 163,849.77 165,280.11 168,645.12 185,379.01 226,915.94
San Mateo-Foster City 5.00 181,844.54 76,477.51 102,810.79 106,826.73 206,916.26 210,454.47 282,214.43
Burlingame Elementary 3.00 172,084.90 84,974.36 82,092.05 132,655.90 183,219.75 217,081.33 250,942.90
Jefferson Elementary 4.00 165,516.35 46,559.08 100,234.65 148,341.09 179,480.12 196,655.38 202,870.52
Jefferson Union High 5.00 143,455.95 50,730.40 64,076.40 141,702.48 142,734.55 166,501.38 202,264.92
Brisbane Elementary 2.00 142,753.63 80,958.44 85,507.37 114,130.50 142,753.63 171,376.76 199,999.89
Belmont-Redwood Shores Elementary 4.00 140,034.66 53,341.11 108,009.34 108,920.61 116,393.77 147,507.83 219,341.77
Ravenswood City Elementary 6.00 128,929.19 38,630.81 67,620.40 111,012.66 134,809.36 150,662.99 177,308.07
Cabrillo Unified 5.00 119,802.87 79,135.06 140.00 93,829.21 145,439.40 146,648.94 212,956.80
Las Lomitas Elementary 2.00 118,226.19 134,536.36 23,094.62 70,660.40 118,226.19 165,791.98 213,357.76
La Honda-Pescadero Unified 1.00 112,249.99 nan 112,249.99 112,249.99 112,249.99 112,249.99 112,249.99
Millbrae Elementary 4.00 101,099.02 72,359.99 50,887.38 65,939.32 72,482.74 107,642.45 208,543.22
Portola Valley Elementary 1.00 86,928.95 nan 86,928.95 86,928.95 86,928.95 86,928.95 86,928.95

2012

Teachers

count mean std min 25% 50% 75% max
Agency
Redwood City Elementary 1.00 106,291.19 nan 106,291.19 106,291.19 106,291.19 106,291.19 106,291.19
Portola Valley Elementary 51.00 103,730.36 36,416.99 12,196.40 82,261.15 116,476.30 131,327.46 147,461.64
San Mateo Union High 448.00 102,353.30 32,984.91 219.40 85,361.62 114,449.71 126,636.85 161,873.28
Menlo Park City Elementary 175.00 98,317.48 27,246.94 16,259.12 86,321.99 107,683.84 118,193.43 138,092.83
Sequoia Union High 464.00 97,122.43 31,663.30 2,369.70 76,631.26 105,907.93 121,048.53 152,706.34
San Mateo County Office of Education 107.00 82,472.19 39,042.44 1,442.17 61,257.54 101,141.14 112,090.66 125,511.89
Belmont-Redwood Shores Elementary 192.00 75,600.08 29,794.20 389.37 61,106.56 82,535.86 100,154.55 120,567.44
Millbrae Elementary 118.00 73,237.94 25,669.15 1,129.65 59,877.69 82,400.92 93,143.48 110,617.36
South San Francisco Unified 475.00 71,240.39 23,378.12 3,571.38 61,071.07 75,791.69 89,006.58 123,700.60
Jefferson Elementary 294.00 70,895.21 20,457.99 8.75 59,641.22 76,396.02 86,299.99 104,356.13
Pacifica School District 1.00 68,010.68 nan 68,010.68 68,010.68 68,010.68 68,010.68 68,010.68
Burlingame Elementary 168.00 67,966.89 23,658.30 124.49 52,334.50 72,235.18 88,342.05 105,432.58
Las Lomitas Elementary 140.00 66,225.80 52,224.62 121.74 4,074.07 76,045.21 117,819.40 143,552.72
San Mateo-Foster City 583.00 65,806.21 24,895.76 5,265.89 47,114.73 72,480.04 86,406.84 104,866.65
Jefferson Union High 254.00 64,031.08 23,561.85 22.25 50,859.10 67,971.27 81,681.20 121,476.34
Ravenswood City Elementary 212.00 58,770.82 25,177.61 154.22 36,492.71 65,393.61 77,108.40 100,902.64
Hillsborough City Elementary 197.00 57,593.77 48,096.59 60.00 2,617.60 65,825.39 106,352.10 136,499.81
Woodside Elementary 69.00 56,385.01 49,752.68 159.06 2,505.80 57,991.67 104,225.30 145,463.08
San Carlos Elementary 229.00 56,255.93 39,349.96 43.71 9,461.09 68,216.61 91,471.21 114,395.08
La Honda-Pescadero Unified 37.00 53,344.68 27,025.29 2,578.48 31,291.49 61,565.28 70,151.45 97,885.36
Bayshore Elementary 30.00 39,795.12 31,961.47 125.00 2,765.62 49,401.62 65,832.02 95,778.24

Managers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 5.00 174,104.23 33,387.58 134,760.28 146,673.48 182,528.68 189,401.66 217,157.07
San Mateo Union High 40.00 155,659.01 49,628.86 42,959.22 136,150.29 166,594.51 184,373.34 256,250.04
Menlo Park City Elementary 12.00 153,029.81 44,490.77 77,499.89 128,323.10 160,746.95 179,149.77 239,775.73
Woodside Elementary 6.00 143,815.89 45,877.68 93,987.86 118,906.88 133,286.08 155,260.05 225,636.79
Sequoia Union High 20.00 140,129.96 51,330.33 46,477.04 99,949.24 148,322.65 176,405.99 247,151.76
Millbrae Elementary 9.00 133,744.92 38,292.60 57,249.90 125,513.55 132,357.43 148,152.90 200,738.98
Belmont-Redwood Shores Elementary 16.00 131,621.45 42,031.48 57,996.80 102,749.76 143,481.64 158,409.88 204,954.78
San Mateo County Office of Education 47.00 130,079.13 41,240.40 12,675.18 106,835.89 136,248.77 154,588.62 225,169.08
Hillsborough City Elementary 14.00 128,102.87 51,783.15 30,864.00 87,667.79 147,531.40 160,847.46 221,387.78
Burlingame Elementary 12.00 127,411.14 59,559.86 10,957.15 118,199.21 139,275.30 148,173.57 235,077.69
Jefferson Elementary 29.00 117,187.37 27,431.75 37,805.39 110,570.22 118,967.39 124,278.10 193,615.91
Las Lomitas Elementary 13.00 110,235.79 48,377.67 16,877.43 78,674.18 106,692.60 156,093.40 171,198.28
South San Francisco Unified 38.00 109,400.35 35,598.72 44,560.16 89,841.21 116,871.70 129,125.99 208,827.57
Bayshore Elementary 2.00 108,843.26 1,063.59 108,091.19 108,467.23 108,843.26 109,219.30 109,595.34
San Mateo-Foster City 42.00 105,700.84 36,863.17 17,001.33 94,126.87 115,873.02 121,896.47 234,083.11
San Carlos Elementary 18.00 98,351.64 54,597.67 3,403.92 56,548.82 115,018.09 127,506.12 213,404.86
Jefferson Union High 40.00 81,511.95 39,625.50 3,157.57 54,059.02 83,058.49 112,827.14 188,310.28
Ravenswood City Elementary 49.00 77,946.44 43,784.66 634.90 48,116.54 81,401.92 109,808.79 195,853.86
La Honda-Pescadero Unified 10.00 71,033.29 34,483.41 11,674.89 53,208.45 81,347.48 97,472.76 108,030.18

Superintendents

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 4.00 230,625.29 29,103.18 193,249.36 214,840.83 236,500.89 252,285.35 256,250.04
Woodside Elementary 1.00 225,636.79 nan 225,636.79 225,636.79 225,636.79 225,636.79 225,636.79
Portola Valley Elementary 1.00 217,157.07 nan 217,157.07 217,157.07 217,157.07 217,157.07 217,157.07
San Carlos Elementary 1.00 213,404.86 nan 213,404.86 213,404.86 213,404.86 213,404.86 213,404.86
Menlo Park City Elementary 2.00 209,161.91 43,294.48 178,548.09 193,855.00 209,161.91 224,468.82 239,775.73
Sequoia Union High 5.00 194,607.12 45,026.72 123,080.69 192,645.34 202,900.91 207,256.90 247,151.76
San Mateo County Office of Education 5.00 188,638.23 24,029.25 161,722.01 175,217.87 184,915.87 196,166.34 225,169.08
Burlingame Elementary 3.00 188,365.39 40,581.49 161,795.59 165,009.23 168,222.88 201,650.29 235,077.69
Hillsborough City Elementary 2.00 184,538.99 52,112.06 147,690.20 166,114.60 184,538.99 202,963.39 221,387.78
San Mateo-Foster City 5.00 169,046.54 47,319.74 100,336.47 169,609.29 170,032.57 171,171.25 234,083.11
Jefferson Elementary 4.00 157,477.89 43,305.21 97,906.38 139,552.79 169,194.64 187,119.75 193,615.91
South San Francisco Unified 4.00 156,671.99 39,689.03 112,415.30 140,551.02 152,722.54 168,843.52 208,827.57
Ravenswood City Elementary 3.00 155,942.76 34,667.09 133,316.02 135,987.21 138,658.40 167,256.13 195,853.86
Belmont-Redwood Shores Elementary 4.00 150,244.52 47,646.82 109,660.76 110,668.93 143,181.27 182,756.86 204,954.78
Millbrae Elementary 2.00 150,137.01 71,561.99 99,535.04 124,836.02 150,137.01 175,438.00 200,738.98
Jefferson Union High 6.00 116,717.11 59,560.41 11,790.66 104,079.25 128,001.29 143,070.73 188,310.28
La Honda-Pescadero Unified 1.00 108,030.18 nan 108,030.18 108,030.18 108,030.18 108,030.18 108,030.18
Las Lomitas Elementary 3.00 104,582.00 24,919.65 78,674.18 92,683.39 106,692.60 117,535.91 128,379.22